﻿USE [Background]
GO
 
 
 if exists (select * from sysobjects where id = OBJECT_ID('[PkIdTable]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [PkIdTable]

CREATE TABLE [PkIdTable] (
[IDNum] [int]  NOT NULL,
[Code] [varchar]  (100) NOT NULL,
[About] [varchar]  (50) NULL)

ALTER TABLE [PkIdTable] WITH NOCHECK ADD  CONSTRAINT [PK_PkIdTable] PRIMARY KEY  NONCLUSTERED ( [Code] )
INSERT [PkIdTable] ([IDNum],[Code],[About]) VALUES ( 5,N'WebDepartments',N'部门')
INSERT [PkIdTable] ([IDNum],[Code],[About]) VALUES ( 110,N'WebManageMenus',N'菜单')
INSERT [PkIdTable] ([IDNum],[Code],[About]) VALUES ( 20,N'WebManageRoles',N'角色')
INSERT [PkIdTable] ([IDNum],[Code],[About]) VALUES ( 11,N'WebManageUsers',N'用户')

if exists (select * from sysobjects where id = OBJECT_ID('[WebDepartments]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [WebDepartments]

CREATE TABLE [WebDepartments] (
[DepartmentID] [int]  NOT NULL,
[DepartmentName] [varchar]  (50) NOT NULL,
[About] [varchar]  (500) NOT NULL,
[ParentID] [int]  NOT NULL,
[SortNumber] [int]  NOT NULL,
[UpdateDate] [datetime]  NOT NULL,
[Operator] [varchar]  (50) NULL,
[Status] [int]  NOT NULL)

ALTER TABLE [WebDepartments] WITH NOCHECK ADD  CONSTRAINT [PK_WebDepartments] PRIMARY KEY  NONCLUSTERED ( [DepartmentID] )
INSERT [WebDepartments] ([DepartmentID],[DepartmentName],[About],[ParentID],[SortNumber],[UpdateDate],[Operator],[Status]) VALUES ( 1,N'公司',N'公司',0,1,N'2011/4/1 0:00:00',N'zzl',100)
INSERT [WebDepartments] ([DepartmentID],[DepartmentName],[About],[ParentID],[SortNumber],[UpdateDate],[Status]) VALUES ( 3,N'技术部',N'技术部11',1,5,N'2012/5/17 17:58:36',100)
INSERT [WebDepartments] ([DepartmentID],[DepartmentName],[About],[ParentID],[SortNumber],[UpdateDate],[Status]) VALUES ( 4,N'人事部',N'人事部',1,0,N'2012/6/11 16:52:47',100)
INSERT [WebDepartments] ([DepartmentID],[DepartmentName],[About],[ParentID],[SortNumber],[UpdateDate],[Status]) VALUES ( 5,N'好人部',N'好人部',4,0,N'2012/6/11 16:52:55',100)

if exists (select * from sysobjects where id = OBJECT_ID('[WebManageUsers]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [WebManageUsers]

CREATE TABLE [WebManageUsers] (
[ManageUserID] [int]  NOT NULL,
[LoginName] [varchar]  (20) NOT NULL,
[LoginNameSpell] [varchar]  (20) NOT NULL,
[Password] [varchar]  (50) NOT NULL,
[RealName] [varchar]  (20) NOT NULL,
[Gender] [varchar]  (10) NOT NULL,
[IntroductionURL] [varchar]  (500) NOT NULL,
[Phone] [varchar]  (20) NULL,
[Mobile] [varchar]  (20) NOT NULL,
[Email] [varchar]  (50) NULL,
[AvatarUrl] [varchar]  (300) NOT NULL,
[QQ] [varchar]  (20) NULL,
[MSN] [varchar]  (50) NULL,
[Rtx] [varchar]  (20) NULL,
[Birthday] [varchar]  (20) NULL,
[Description] [ntext]  NULL,
[DepartmentID] [int]  NOT NULL,
[CreateDate] [datetime]  NOT NULL,
[UpdateDate] [datetime]  NULL,
[Operator] [varchar]  (50) NULL,
[Status] [int]  NOT NULL)

ALTER TABLE [WebManageUsers] WITH NOCHECK ADD  CONSTRAINT [PK_WebManageUsers] PRIMARY KEY  NONCLUSTERED ( [ManageUserID] )
INSERT [WebManageUsers] ([ManageUserID],[LoginName],[Password],[RealName],[Gender],[Phone],[Mobile],[Email],[Birthday],[Description],[DepartmentID],[CreateDate],[UpdateDate],[Status]) VALUES ( 5,N'opt',N'17987070c6f2bd94b4a67d4d4df850eb',N'运营部1',N'1',N'80357765',N'13521972991',N'bfyxzls@sina.com',N'2011-12-09',N'safasdfasdfadsfdsafdasfasd',1,N'2011/12/9 10:57:16',N'2013/1/7 11:26:04',100)
INSERT [WebManageUsers] ([ManageUserID],[LoginName],[Password],[RealName],[Gender],[Phone],[Mobile],[Email],[Birthday],[Description],[DepartmentID],[CreateDate],[UpdateDate],[Operator],[Status]) VALUES ( 6,N'zzl',N'17987070C6F2BD94B4A67D4D4DF850EB',N'伟大的占占',N'0',N'80357765',N'13521972991',N'bfyxzls@sina.com',N'2012-04-23',N'伟大的占占',1,N'2012/4/23 17:09:12',N'2012/4/23 17:09:12',N'匿名',100)
INSERT [WebManageUsers] ([ManageUserID],[LoginName],[Password],[RealName],[Gender],[Phone],[Mobile],[Email],[Birthday],[Description],[DepartmentID],[CreateDate],[UpdateDate],[Operator],[Status]) VALUES ( 7,N'bobo',N'17987070C6F2BD94B4A67D4D4DF850EB',N'波波',N'0',N'80357765',N'13521972991',N'bobo@sina.com',N'2012-04-25',N'要苛',1,N'2012/4/25 14:02:51',N'2012/4/25 14:02:51',N'匿名',100)
INSERT [WebManageUsers] ([ManageUserID],[LoginName],[Password],[RealName],[Gender],[Phone],[Mobile],[Email],[Birthday],[Description],[DepartmentID],[CreateDate],[UpdateDate],[Operator],[Status]) VALUES ( 8,N'niuren',N'17987070C6F2BD94B4A67D4D4DF850EB',N'牛人',N'0',N'80357765',N'13521972991',N'niuren@sina.com',N'2012-04-17',N'模压枯',1,N'2012/4/25 15:40:23',N'2012/4/25 15:40:23',N'匿名',100)
INSERT [WebManageUsers] ([ManageUserID],[LoginName],[Password],[RealName],[Gender],[Phone],[Mobile],[Email],[Birthday],[Description],[DepartmentID],[CreateDate],[UpdateDate],[Operator],[Status]) VALUES ( 9,N'should',N'17987070C6F2BD94B4A67D4D4DF850EB',N'应该没问题',N'0',N'80357765',N'13521972991',N'should@sina.com',N'2012-04-17',N'大师傅基',1,N'2012/4/25 16:20:29',N'2012/4/25 16:20:29',N'匿名',100)
INSERT [WebManageUsers] ([ManageUserID],[LoginName],[Password],[RealName],[Gender],[Phone],[Mobile],[Email],[Birthday],[Description],[DepartmentID],[CreateDate],[UpdateDate],[Operator],[Status]) VALUES ( 10,N'opttest',N'17987070C6F2BD94B4A67D4D4DF850EB',N'测试工厂',N'0',N'80357765',N'13521972991',N'opttest@sina.com',N'2012-06-07',N'fasdsasfasd',1,N'2012/6/7 11:01:02',N'2012/6/7 11:01:02',N'匿名',100)
INSERT [WebManageUsers] ([ManageUserID],[LoginName],[Password],[RealName],[Gender],[Phone],[Mobile],[Email],[Birthday],[Description],[DepartmentID],[CreateDate],[UpdateDate],[Operator],[Status]) VALUES ( 11,N'testfactory',N'C15D9A5944A58856C6DF6B15C1550A58',N'测试工厂２',N'0',N'80357765',N'13521972991',N'opttest@sina.com',N'2012-06-07',N'１２３４５',1,N'2012/6/7 11:08:06',N'2012/6/7 11:08:06',N'匿名',400)


if exists (select * from sysobjects where id = OBJECT_ID('[WebEntityLogs]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [WebEntityLogs]

CREATE TABLE [WebEntityLogs] (
[ID] [bigint]  NOT NULL,
[Title] [varchar]  (200) NULL,
[Info] [text]  NULL,
[CreateDate] [datetime]  NULL,
[Operator] [varchar]  (100) NULL)

ALTER TABLE [WebEntityLogs] WITH NOCHECK ADD  CONSTRAINT [PK_WebEntityLogs] PRIMARY KEY  NONCLUSTERED ( [ID] )
INSERT [WebEntityLogs] ([ID],[Title],[Info],[CreateDate],[Operator]) VALUES ( 1,N'帮助中心',N'新闻中心',N'2012/6/1 16:40:04',N'zzl')
INSERT [WebEntityLogs] ([ID],[Title],[Info],[CreateDate],[Operator]) VALUES ( 2,N'帮助中心',N'信息从帮助中心<=修改成了=>帮助中心1',N'2012/6/1 17:58:57',N'zzl')

if exists (select * from sysobjects where id = OBJECT_ID('[WebManageMenus]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [WebManageMenus]

CREATE TABLE [WebManageMenus] (
[MenuID] [int]  NOT NULL,
[MenuName] [varchar]  (50) NOT NULL,
[ParentID] [int]  NOT NULL,
[MenuLevel] [int]  NOT NULL,
[LinkUrl] [varchar]  (300) NULL,
[About] [varchar]  (200) NOT NULL,
[SortNumber] [int]  NOT NULL,
[UpdateDate] [datetime]  NOT NULL,
[Operator] [varchar]  (50) NULL,
[Status] [int]  NOT NULL)

ALTER TABLE [WebManageMenus] WITH NOCHECK ADD  CONSTRAINT [PK_WebManageMenus] PRIMARY KEY  NONCLUSTERED ( [MenuID] )
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Operator],[Status]) VALUES ( 1,N'根',0,0,N'javascript:void(0);',N'javascript:void(0);',1,N'2012/1/1 0:00:00',N'2011-11-21 13:49:08',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 2,N'系统管理',1,0,N'/system/WebWebManageMenusList',N'/system/WebWebManageMenusList',1,N'2012/5/2 9:08:59',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 3,N'职位管理',2,0,N'/system/webmanageroleslist',N'/system/webmanageroleslist',1,N'2012/5/17 17:08:47',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Operator],[Status]) VALUES ( 4,N'部门管理',2,2,N'/system/webdepartmentslist',N'/system/webdepartmentslist',1,N'2012/1/1 0:00:00',N'2011-12-5 10:36:28',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 5,N'员工管理',2,0,N'/system/webmanageuserlist',N'/system/webmanageuserlist',3,N'2012/11/12 13:49:47',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Operator],[Status]) VALUES ( 6,N'菜单管理',2,2,N'/system/WebWebManageMenusList',N'/system/WebWebManageMenusList',1,N'2012/1/1 0:00:00',N'2011-12-5 10:39:45',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 7,N'新增职位',3,0,N'/system/webmanageroles',N'/system/webmanageroles',1,N'2012/5/17 17:09:25',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 8,N'职位管理',3,0,N'/system/webmanageroleslist',N'/system/webmanageroleslist',1,N'2012/5/17 17:09:53',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Operator],[Status]) VALUES ( 9,N'部门管理',4,3,N'/system/webdepartmentslist',N'/system/webdepartmentslist',1,N'2012/1/1 0:00:00',N'2011-12-5 10:36:28',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Operator],[Status]) VALUES ( 10,N'员工管理',5,3,N'/system/webmanageuserlist',N'/system/webmanageuserlist',1,N'2012/1/1 0:00:00',N'2011-12-5 10:39:07',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Operator],[Status]) VALUES ( 11,N'菜单管理',6,3,N'/system/WebWebManageMenusList',N'/system/WebWebManageMenusList',1,N'2012/1/1 0:00:00',N'2011-12-5 10:40:40',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 45,N'用户管理',44,0,N'javascript:void(0)',N'用户管理',0,N'2012/7/5 11:54:40',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 46,N'问答管理',44,0,N'javascript:void(0)',N'回答管理',0,N'2012/7/5 11:55:18',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 47,N'标签管理',1,1,N'javascript:void(0)',N'标签管理',0,N'2012/7/5 11:49:07',400)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 48,N'标签管理',44,0,N'Http//Manage.158.cn/Tag/AddTag',N'标签管理',0,N'2012/7/5 12:01:55',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 49,N'用户列表',45,0,N'/UserInfo/UserInfoList.shtml',N'用户列表',0,N'2012/7/5 13:24:30',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 50,N'添加用户',45,0,N'/UserInfo/AddUser.shtml',N'添加用户',0,N'2012/7/5 13:26:34',400)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 51,N'回答管理',46,0,N'/AnswerQuestion/AnswerList.shtml',N'回答管理',0,N'2012/7/5 13:32:19',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 52,N'问题管理',46,0,N'/AnswerQuestion/QuestionList.shtml',N'问题管理',0,N'2012/7/5 13:29:35',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 53,N'评论管理',46,0,N'/AnswerQuestion/CommentList.shtml',N'评论管理',0,N'2012/7/5 13:27:11',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 54,N'审核用户管理',45,3,N'http://manage.158.cn/UserInfo/UserRegistApply',N'审核用户管理',0,N'2012/7/5 11:57:32',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 55,N'标签列表',48,0,N'/Tag/TagList',N'标签列表',0,N'2012/7/5 13:27:23',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 56,N'添加标签',48,0,N'/Tag/AddTag',N'添加标签',0,N'2012/7/9 14:41:16',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 57,N'邮件发送模板管理',44,0,N'javascript:void(0)',N'发送邮件模板管理',0,N'2012/7/5 13:31:34',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 58,N'邮件模板列表',57,1,N'/MailTemplate/MailTemplateList',N'邮件模板列表',0,N'2012/7/9 13:43:35',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 60,N'内容管理',1,0,N'javascript:void(0)',N'内容管理',10,N'2012/11/27 14:55:51',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 62,N'管理工作室',61,3,N'/Workshop/Index',N'工作室的增删改查',0,N'2012/11/26 11:30:48',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 64,N'管理相关机构',63,3,N'/Agency/Index',N'管理相关机构',0,N'2012/11/26 11:33:06',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 66,N'管理专业吧',65,3,N'/Specialty/Index',N'管理专业吧',0,N'2012/11/26 11:34:35',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 68,N'管理用户',67,0,N'/User_Info/Index',N'管理用户',0,N'2012/12/10 10:54:10',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 70,N'标签管理',69,0,N'/Common_Tag/Index',N'工作室标签列表页',0,N'2012/12/14 13:35:21',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 72,N'活动管理',71,2,N'/Activity_Info/Index',N'综合区活动管理',0,N'2012/12/25 11:51:04',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 73,N'推荐区域管理',71,2,N'/Recommend/FocusPictures',N'推荐区域管理',0,N'2012/12/25 11:52:41',0)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 74,N'活动公告',72,0,N'/Activity_Announcement/Index',N'活动公告管理',1,N'2012/12/27 11:26:25',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 75,N'作品管理',72,0,N'/ActivityMedia/Index',N'作品管理',1,N'2012/12/27 11:27:40',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 76,N'话题讨论',72,0,N'/ActivityTopic/Index',N'话题讨论',0,N'2012/12/27 11:29:59',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 78,N'话题管理',77,1,N'/Topic_Info/Index',N'话题管理',0,N'2013/1/7 11:20:27',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 80,N'作品管理',79,0,N'/MediaInfo/Index',N'管理所有作品',0,N'2013/1/8 16:17:38',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 82,N'经验值管理',81,2,N'/Config/EmpiricalList',N'经验值管理',0,N'2013/1/21 11:26:08',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 84,N'API信息管理',83,2,N'/Config/ApiDynamic',N'API信息管理',0,N'2013/1/21 11:27:25',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 86,N'任务管理',85,2,N'/Task/Index',N'任务管理',0,N'2013/1/22 9:15:48',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 88,N'道具管理',87,2,N'/Props_Info/Index',N'道具管理',0,N'2013/1/22 9:16:45',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 90,N'www.baidu.com',89,2,N'//',N'http://www.baidu.com',0,N'2013/1/22 9:53:33',0)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 92,N'艺吧后台管理',60,1,N'艺吧后台管理',N'艺吧后台管理',0,N'2013/1/22 10:53:59',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 93,N'工作室管理',92,2,N'/Workshop/Index',N'工作室管理',0,N'2013/1/22 10:54:38',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 94,N'机构管理',92,0,N'/Agency/Index',N'机构管理',0,N'2013/1/22 10:56:42',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 95,N'专业吧管理',92,2,N'/Specialty/Index',N'专业吧管理',0,N'2013/1/22 10:58:09',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 96,N'用户管理',92,2,N'/User_Info/Index',N'用户管理',0,N'2013/1/22 10:59:07',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 97,N'工作室标签管理',92,2,N'/Common_Tag/Index',N'工作室标签管理',0,N'2013/1/22 11:00:41',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 98,N'综合区活动管理',92,0,N'/Activity_Info/Index',N'活动管理',0,N'2013/1/22 11:03:54',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 99,N'综合推荐区管理',92,2,N'/Recommend/FocusPictures',N'综合推荐区管理',0,N'2013/1/22 11:05:14',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 100,N'话题讨论',98,1,N'/ActivityTopic/Index',N'话题讨论',0,N'2013/1/22 11:06:02',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 101,N'活动公告',98,0,N'/Activity_Announcement/Index',N'公告管理',0,N'2013/1/22 11:07:47',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 102,N'作品管理',98,1,N'/ActivityMedia/Index',N'作品管理',0,N'2013/1/22 11:08:28',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 103,N'话题管理',92,2,N'/Topic_Info/Index',N'话题管理',0,N'2013/1/22 11:09:13',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 104,N'作品管理',92,2,N'/MediaInfo/Index',N'作品管理',0,N'2013/1/22 11:10:25',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 105,N'经验值管理',92,2,N'/Config/EmpiricalList',N'经验值管理',0,N'2013/1/22 11:11:49',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 106,N'API信息管理',92,0,N'/Config/ApiDynamic',N'API信息管理',0,N'2013/1/22 11:18:00',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 107,N'任务管理',92,2,N'/Task/Index',N'任务管理',0,N'2013/1/22 11:18:32',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 108,N'道具管理',92,2,N'/Props_Info/Index',N'道具管理',0,N'2013/1/22 11:18:58',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 109,N'粉丝管理',92,2,N'/User_Info/SelectFuns',N'粉丝管理',0,N'2013/1/29 9:14:25',100)
INSERT [WebManageMenus] ([MenuID],[MenuName],[ParentID],[MenuLevel],[LinkUrl],[About],[SortNumber],[UpdateDate],[Status]) VALUES ( 110,N'第三方用户管理',92,2,N'/User_Info/ThirdUser',N'第三方用户管理',0,N'2013/1/29 9:15:30',100)


if exists (select * from sysobjects where id = OBJECT_ID('[WebManagePermissions]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [WebManagePermissions]

CREATE TABLE [WebManagePermissions] (
[PermissionsID] [int]  NOT NULL,
[Name] [varchar]  (100) NOT NULL,
[Status] [int]  NOT NULL,
[CreateDate] [datetime]  NOT NULL,
[UpdateDate] [datetime]  NOT NULL)

ALTER TABLE [WebManagePermissions] WITH NOCHECK ADD  CONSTRAINT [PK_WebManagePermissions] PRIMARY KEY  NONCLUSTERED ( [PermissionsID] )
INSERT [WebManagePermissions] ([PermissionsID],[Name],[Status],[CreateDate],[UpdateDate]) VALUES ( 1,N'没有权限',100,N'2010/6/1 0:00:00',N'2010/6/1 0:00:00')
INSERT [WebManagePermissions] ([PermissionsID],[Name],[Status],[CreateDate],[UpdateDate]) VALUES ( 2,N'查看事件',100,N'2010/6/1 0:00:00',N'2010/6/1 0:00:00')
INSERT [WebManagePermissions] ([PermissionsID],[Name],[Status],[CreateDate],[UpdateDate]) VALUES ( 4,N'添加事件',100,N'2010/6/1 0:00:00',N'2010/6/1 0:00:00')
INSERT [WebManagePermissions] ([PermissionsID],[Name],[Status],[CreateDate],[UpdateDate]) VALUES ( 8,N'修改事件',100,N'2010/6/1 0:00:00',N'2010/6/1 0:00:00')
INSERT [WebManagePermissions] ([PermissionsID],[Name],[Status],[CreateDate],[UpdateDate]) VALUES ( 16,N'删除事件',100,N'2010/6/1 0:00:00',N'2010/6/1 0:00:00')
INSERT [WebManagePermissions] ([PermissionsID],[Name],[Status],[CreateDate],[UpdateDate]) VALUES ( 32,N'审批事件',100,N'2010/6/1 0:00:00',N'2010/6/1 0:00:00')
INSERT [WebManagePermissions] ([PermissionsID],[Name],[Status],[CreateDate],[UpdateDate]) VALUES ( 64,N'订阅事件',100,N'2010/6/1 0:00:00',N'2010/6/1 0:00:00')


if exists (select * from sysobjects where id = OBJECT_ID('[WebManageRole_WebManageMenus]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [WebManageRole_WebManageMenus]

CREATE TABLE [WebManageRole_WebManageMenus] (
[ManageRoleID] [int]  NOT NULL,
[MenuID] [int]  NOT NULL)

ALTER TABLE [WebManageRole_WebManageMenus] WITH NOCHECK ADD  CONSTRAINT [PK_WebManageRole_WebManageMenus] PRIMARY KEY  NONCLUSTERED ( [ManageRoleID],[MenuID] )
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,47)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,60)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,61)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,62)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,63)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,64)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,65)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,66)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,67)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,68)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,69)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,70)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,71)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,72)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,73)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,74)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,75)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 1,76)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,47)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,60)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,61)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,62)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,63)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,64)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,65)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,66)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,67)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,68)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,69)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,70)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,71)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,72)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,73)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,74)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,75)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 2,76)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 3,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 3,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 3,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 3,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 3,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 3,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 3,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 3,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 3,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 3,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 3,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,47)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,60)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,92)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,93)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,94)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,95)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,96)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,97)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,98)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,99)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,100)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,101)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,102)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,103)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,104)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,105)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,106)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,107)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,108)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,109)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 4,110)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 5,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 5,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 5,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 5,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 5,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 5,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 5,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 5,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 5,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 5,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 5,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,47)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,60)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,61)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,62)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,63)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,64)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,65)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,66)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,67)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,68)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,69)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,70)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,71)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,72)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,73)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,74)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,75)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 6,76)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,12)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,13)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,14)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,15)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,16)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,18)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,19)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,20)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,21)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,22)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,23)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,24)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,25)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,26)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,27)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,28)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,29)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,30)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,31)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,32)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,33)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,34)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,35)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,36)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 7,37)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,47)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,60)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,61)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,62)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,63)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,64)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,65)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,66)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,67)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,68)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,69)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,70)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,71)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,72)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 8,73)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,12)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,13)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,14)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,15)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,16)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,18)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,19)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,20)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,21)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,22)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,23)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,24)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,25)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,26)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,27)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,28)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,29)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,30)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,31)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,32)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,33)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,34)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,35)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,36)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,37)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,39)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,40)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,41)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,42)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 9,43)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,12)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,13)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,14)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,15)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,16)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,17)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,18)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,19)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,20)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,21)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,22)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,23)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,24)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,25)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,26)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,27)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,28)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,29)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,30)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,31)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,32)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,33)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,34)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,35)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,36)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,37)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,38)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,39)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,40)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,41)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,42)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 11,43)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,12)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,13)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,14)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,15)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,16)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,17)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,18)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,19)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,20)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,21)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,22)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,23)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,24)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,25)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,26)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,27)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,28)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,29)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,30)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,31)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,32)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,33)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,34)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,35)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,36)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,37)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,38)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,39)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,40)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,41)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,42)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 13,43)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 14,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 14,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 14,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 14,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 14,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 14,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 14,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 14,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 14,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 14,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 14,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,47)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,60)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,61)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,62)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,63)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,64)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,65)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,66)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,67)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,68)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,69)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,70)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,71)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,72)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,73)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,74)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,75)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 15,76)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,47)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 16,59)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,47)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,60)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,61)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,62)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,63)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,64)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,65)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,66)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,67)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,68)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,69)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,70)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,71)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,72)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 17,73)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,47)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,59)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,60)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,61)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,62)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,63)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,64)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,65)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,66)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,67)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 18,68)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,47)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,60)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,61)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,62)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,63)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,64)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,65)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,66)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,67)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,68)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,69)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,70)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,71)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,72)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,73)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,74)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,75)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 19,76)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,1)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,2)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,3)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,4)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,5)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,6)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,7)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,8)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,9)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,10)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,11)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,47)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,60)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,61)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,62)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,63)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,64)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,65)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,66)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,67)
INSERT [WebManageRole_WebManageMenus] ([ManageRoleID],[MenuID]) VALUES ( 20,68)


if exists (select * from sysobjects where id = OBJECT_ID('[WebManageRoles]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [WebManageRoles]

CREATE TABLE [WebManageRoles] (
[ManageRoleID] [int]  NOT NULL,
[RoleName] [varchar]  (50) NOT NULL,
[DepartmentID] [int]  NOT NULL,
[About] [varchar]  (200) NOT NULL,
[UpdateDate] [nchar]  (10) NOT NULL,
[SortNumber] [int]  NOT NULL,
[Operator] [varchar]  (50) NOT NULL,
[Status] [int]  NOT NULL,
[OperatorAuthority] [int]  NOT NULL)

ALTER TABLE [WebManageRoles] WITH NOCHECK ADD  CONSTRAINT [PK_WebManageRoles] PRIMARY KEY  NONCLUSTERED ( [ManageRoleID] )
INSERT [WebManageRoles] ([ManageRoleID],[RoleName],[DepartmentID],[About],[UpdateDate],[SortNumber],[Operator],[Status],[OperatorAuthority]) VALUES ( 1,N'管理员',1,N'管理员11',N'13-01-07',1,N'opt',100,30)
INSERT [WebManageRoles] ([ManageRoleID],[RoleName],[DepartmentID],[About],[UpdateDate],[SortNumber],[Operator],[Status],[OperatorAuthority]) VALUES ( 2,N'总经理',1,N'总经理',N'13-01-07',1,N'opt',100,62)
INSERT [WebManageRoles] ([ManageRoleID],[RoleName],[DepartmentID],[About],[UpdateDate],[SortNumber],[Operator],[Status],[OperatorAuthority]) VALUES ( 4,N'部门经理',1,N'部门经理',N'13-01-29',1,N'opt',100,62)
INSERT [WebManageRoles] ([ManageRoleID],[RoleName],[DepartmentID],[About],[UpdateDate],[SortNumber],[Operator],[Status],[OperatorAuthority]) VALUES ( 6,N'测试',1,N'测试',N'13-01-07',1,N'opt',100,62)
INSERT [WebManageRoles] ([ManageRoleID],[RoleName],[DepartmentID],[About],[UpdateDate],[SortNumber],[Operator],[Status],[OperatorAuthority]) VALUES ( 8,N'管理员',1,N'管理员',N'12-12-27',1,N'opt',100,78)
INSERT [WebManageRoles] ([ManageRoleID],[RoleName],[DepartmentID],[About],[UpdateDate],[SortNumber],[Operator],[Status],[OperatorAuthority]) VALUES ( 15,N'管理员',1,N'管理员',N'13-01-07',1,N'opt',100,30)
INSERT [WebManageRoles] ([ManageRoleID],[RoleName],[DepartmentID],[About],[UpdateDate],[SortNumber],[Operator],[Status],[OperatorAuthority]) VALUES ( 17,N'管理员',1,N'管理员',N'12-12-27',1,N'opt',100,94)
INSERT [WebManageRoles] ([ManageRoleID],[RoleName],[DepartmentID],[About],[UpdateDate],[SortNumber],[Operator],[Status],[OperatorAuthority]) VALUES ( 19,N'测试',1,N'测试',N'13-01-07',1,N'opt',100,70)


if exists (select * from sysobjects where id = OBJECT_ID('[WebManageUser_Strategy]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [WebManageUser_Strategy]

CREATE TABLE [WebManageUser_Strategy] (
[ID] [int]  NOT NULL,
[ManageUserID] [int]  NOT NULL,
[IPArea] [nvarchar]  (50) NULL,
[BeginDate] [datetime]  NOT NULL,
[EndDate] [datetime]  NOT NULL,
[Status] [int]  NOT NULL,
[CreateDate] [datetime]  NOT NULL)

ALTER TABLE [WebManageUser_Strategy] WITH NOCHECK ADD  CONSTRAINT [PK_WebManageUser_Strategy] PRIMARY KEY  NONCLUSTERED ( [ID] )


if exists (select * from sysobjects where id = OBJECT_ID('[WebManageUser_WebManageRoles]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [WebManageUser_WebManageRoles]

CREATE TABLE [WebManageUser_WebManageRoles] (
[ManageUserID] [int]  NOT NULL,
[ManageRoleID] [int]  NOT NULL)

ALTER TABLE [WebManageUser_WebManageRoles] WITH NOCHECK ADD  CONSTRAINT [PK_WebManageUser_WebManageRoles] PRIMARY KEY  NONCLUSTERED ( [ManageUserID],[ManageRoleID] )
INSERT [WebManageUser_WebManageRoles] ([ManageUserID],[ManageRoleID]) VALUES ( 5,4)
INSERT [WebManageUser_WebManageRoles] ([ManageUserID],[ManageRoleID]) VALUES ( 6,1)
INSERT [WebManageUser_WebManageRoles] ([ManageUserID],[ManageRoleID]) VALUES ( 7,1)
INSERT [WebManageUser_WebManageRoles] ([ManageUserID],[ManageRoleID]) VALUES ( 8,1)
INSERT [WebManageUser_WebManageRoles] ([ManageUserID],[ManageRoleID]) VALUES ( 9,1)
INSERT [WebManageUser_WebManageRoles] ([ManageUserID],[ManageRoleID]) VALUES ( 10,1)
INSERT [WebManageUser_WebManageRoles] ([ManageUserID],[ManageRoleID]) VALUES ( 11,1)
INSERT [WebManageUser_WebManageRoles] ([ManageUserID],[ManageRoleID]) VALUES ( 11,2)

